ALTER TABLE `shopnc_member` ADD `member_tel` VARCHAR( 12 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL